MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Object Name = 16027

View and edit SQL

Suggested facets: Is Public Domain, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Country

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
346970 89.4.1001 0 1 501611 Musical Instruments 18 Dulcimer 16027 Dulcimer Spanish 13                           18th century 1701 1800 wood and various materials 54175 Length - long edge/short edge 99.2/43.5 cm. (38.69 in./17.13 in.) Body width perpendicular to long edge: 46.8 cm. (18.25 in.) Body depth including molding: 7.9 cm. (3.15 in.) Vibrating length of strings: 80.5/30.0 cm (31.40 in./30 in.) Diameter of rosette: 7.5 cm. (2.93 in.) Length of hammers: app. 23.5 cm. (9.17 in.) The Crosby Brown Collection of Musical Instruments, 1889                       Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
346971 89.4.1002a, b 0 1 501612 Musical Instruments 18 Dulcimer 16027 Dulcimer Italian 36         Maker 1   Giovanni Antonio Berera 1711–1799   Berera Giovanni Antonio 47740 Italian 6 1711 1799 1749 1749 1749 Wood and various materials 53951 L. --long edge/short edge: 73.3/ 38.5 cm., Body width perpendicular to long edge 30.0 cm., Body depth including moldin 6.8 cm., Vibrating length of strings 55/ 26 cm., Diamter of soundholes 6.0 cm., Case length--long edge/ short edge 81.7/ 43.5 cm., Case width perpendicular to long edge 36.8 cm., Case depth ca. 14 cm. The Crosby Brown Collection of Musical Instruments, 1889   Trento (South Tyrol) 2185     Italy 14             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
346972 89.4.1003 0 0 501613 Musical Instruments 18 Dulcimer 16027 Dulcimer Italian 36                           18th century 1701 1800 Wood and various materials 53951 Length--long edge/ short edge: 87.5/ 46 cm., Body width perpendicular to long edge: 29.6 cm., Body depth including molding: 8.4 cm., Diamter of rosette: 6.4 cm. The Crosby Brown Collection of Musical Instruments, 1889         Italy 14             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
346973 89.4.1004 0 0 501614 Musical Instruments 18 Dulcimer 16027 Dulcimer French 7                           18th century 1701 1800 Wood and various materials 53951 Length: long edge/ short edge 76/ 40 cm., Body width perpendicular to long edge 33.8 cm., Body depth including molding 6.1 cm, Diameter of rosette 6.7 cm. The Crosby Brown Collection of Musical Instruments, 1889         France 9             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
347364 89.4.1573 0 0 502028 Musical Instruments 18 Dulcimer 16027 Dulcimer Swiss 54                           19th century 1801 1900 wood and various materials 54175 Length (long edge/ short edge) 54.6/ 37.7 cm, Width perpendicular to long edge 22.3 cm, Depth of resonating body 3.6 cm, Diameter of rosette 11/ 13.5 cm, Vibrating length of strings 47.2/ 34 cm The Crosby Brown Collection of Musical Instruments, 1889         Switzerland 52             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
347442 89.4.1533 0 0 502108 Musical Instruments 18 Dulcimer 16027 Dulcimer Probably German 261                           mid-19th century 1833 1867 Wood and various materials. 54355 Length--long edge/ short edge 92.2/ 43 cm, body width perpendicular to long edge 28.5 cm, Body depth ca. 6.7 cm, Diameter of rosettes 2.7 cm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
350219 27.240 0 1 505101 Musical Instruments 18 Dulcimer 16027 Dulcimer Italian 36                           18th century 1700 1800 Wood and various materials 53951 L. long edge/short edge: 73.5/36.7 cm; W. perpendicular to long edge: 33.4 cm; D. 6.3 cm; Diam. of rosette: 5.5 cm; Vibrating L. of strings: 60.5/27.5 cm Gift of Eva Mali Noyes, 1927         Italy 14             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 118.671ms · Data license: CC0 · Data source: metmuseum/openaccess